Modular application development in a spreadsheet using indication values

ABSTRACT

A graphical application developing and managing environment is described capable of representing and editing program modules using multiple display formats, which include embedding source code written in a functional language into a spreadsheet-like format. Methods are described for enabling the sharing of program modules by defining standardized interfaces into program modules and existing documents and by centrally locating module definitions. A patchwork mechanism is described requiring only basic spreadsheet editing skills on behalf of the user, enabling a user of the environment to connect external documents and program modules into a new program application. The invention allows complicated programming and simple end-user programming to be achieved within a unified environment and allows the execution of program modules and tracing of variables simultaneously with the writing of a program application. The invention defines methods for representing the various parts of a source code, defining a program application, along with the application icon as determined by a user creating the application and thereby making parts of the source code accessible to end-users for run-time execution.

This application is a continuation of application Ser. No. 09/781,294,filed on Feb. 13, 2001 now U.S. Pat. No. 6,763,498, which is adivisional of application Ser. No. 08/690,919, filed on Aug. 1, 1996 nowU.S. Pat. No. 6,286,017, which is a continuation-in-part ofInternational PCT Application No. PCT/DK9600080, filed Feb. 22, 1996 andapplication Ser. No. 08/392,164 filed Feb. 22, 1995 now abandoned, theentire contents of each of which are hereby incorporated by referenceand for which priority is claimed under 35 U.S.C. §120.

TECHNICAL FIELD

In general the present invention relates to an application buildingenvironment. More specifically, the present invention relates to anapplication building and managing environment in which users of computersystems, including ones with minimal programming knowledge, create andshare powerful software applications.

BACKGROUND OF THE INVENTION

In a conventional application building environment such as in most thirdand fourth-generation programming languages, the task of constructing anapplication requires intensive knowledge of specialized methods andstructures. Existing application environments do not enable end-userswith limited programming knowledge to combine program modules from otherusers and program developers into complicated applications. The sharingof program components is done on a level inaccessible by the end-user.Furthermore, existing systems do not combine programming at differentskill and complication levels into a unified environment where complexprogramming and simple end-user programming follow the same approach.The components of an application are usually rigorously embedded intothe program source code either in the form of text or as a combinationof text and objects. This results in difficulties in sharing computercomponents. Module and data dictionaries and well organized programlibraries provide a partial solution to this problem. However there arestill very limited possibilities for end-users of computer systems toshare or even build complicated applications involving rich modularprogramming structure without intensive knowledge of a complicatedprogramming environment.

The introduction of multidimensional spreadsheets allows users of suchsystems to create more complicated calculation models through a smoothtransaction from two-dimensional spreadsheets and is thus a step towardmaking applications manageable by the end-user. Current spreadsheetsystems however do not focus the user's attention on the underlyinglogical modular structure ever-present in an application. Furthermorecurrent spreadsheet systems do not generalize the spreadsheet concept insuch a way that powerful programming techniques can be applied withoutleaving the methodology of the spreadsheet environment but insteademploy add-on techniques such as the writing of macros to enhanceusability.

There exist numerous source code generators and fourth generationprogramming environments using graphical structures as part ofapplication generation. Source code generators however and most otherapplication building environments, by definition, are intended forprogram development and provide an environment for developingapplications which is entirely different from the end-user environment.Thus the end user is separated from the application building environmentand is unable to create or share application components without movingup to the application developing level.

U.S. Pat. No. 4,956,773, issued Sep. 11, 1990 to Saito et al., describesmethods for creating programs using various diagrams. The Saito patentis directed to an apparatus for automatically creating a source program,in particular the coding of the source program is automaticallyperformed from program specifications which the programmer generates, inorder to reduce the burden required to create such a source program. Asillustrated in FIG. 11 of Saito the source code is automaticallygenerated from a module structure diagram.

U.S. Pat. No. 5,255,363, issued Oct. 19, 1993 to Seyler, describesmethods for writing programs within a spreadsheet application. TheSeyler patent is directed to a graphical programming system with aspreadsheet base for enabling users to create graphical programs fordisplaying and manipulating data. The Seyler invention allows a user tocreate graphical programs which can monitor parameters (such as cost andreliability) and provide feedback during the design of electronicsystems, such as circuit boards.

U.S. Pat. No. 5,317,686, issued May 31, 1994 to Salas et al., describesrelabeling of spreadsheet cells. The Salas et al patent is directed toan apparatus and labeling scheme which permits a user to reformat,redefine, and relabel the various cells of a multidimensionalspreadsheet. The Salas et al patent also permits the creation ofmultidimensional spreadsheets where calculations are specified throughgeneral, rather than per cell, formulae.

SUMMARY OF THE INVENTION

An object of the present invention is to provide a graphical applicationdeveloping and managing environment in which the building and sharing ofapplication components is done largely by the end-user.

The above object is accomplished by combining a graphical logicalmodular structure diagram, methods for embedding source code for a classof programming languages into a visual spreadsheet-like format, andstandardized interfaces into modules and external applications.

Central to the present invention is the definition of an indicationvalue system which allows spreadsheet methodology to be applied to anadvanced functional language. The indication value system is anextremely practical invention since it empowers the spreadsheet user tocreate general software applications without having to abandon thespreadsheet methodology. It thus addresses the well known challenge ofend-user empowerment in the creation of software components.

Modular structure is present in any software application and can bevisualized in many different ways depending on which program parts aregrouped together to form a module and how they are interconnected.However the term logical modular structure used above represents amodular structure describing a solution to a specific task anapplication is intended to perform.

According to the present invention, application or module building canbe done by drawing on a display unit a logical modular structure diagramdescribing how the new module is connected to other modules representingexisting applications, previously written modules and unfinishedmodules. Using this diagram detailed description about the applicationis attached to the various parts of the diagram so as to represent theflow of information between the modules and the manipulation and visualrepresentation of information. The new module is assigned an interfacepart. The interface part is a standardized interface, through whichfuture applications communicate, and which can be used as an interfaceto external applications such as databases. The present invention thusenables the creation of standardized interfaces, visually represented,into modules including modules which overlay external applications.

The present invention provides methods for using as an equivalentalternative to the text format a spreadsheet-like format when writingand executing source code written in a functional programming language,methods for moving back and forth from the spreadsheet format and thetraditional text format and methods for attaching source code to theparts of the above logical modular structure diagram.

There exist many different ways to define statements in a functionallanguage, or any language for that matter, other than using traditionaltext definitions. The methods described herein also apply in cases whenalternatives to the text format are used. This can be verified bynoticing that one can translate alternative representations of code intothe traditional text format. The patchwork mechanism, which will bedescribed in details below, can be considered to be a graphicalrepresentation/definition of statements defining calls to child modulesand is thus an example of an alternative to the text format for suchstatements. The patchwork mechanism employs the cell format, describedherein also, to define parent-child module relationships in an end-userfriendly way.

The term functional programming language or a functional language refersto a programming language in which each statement written in thelanguage can be evaluated, based on its dependent variables, to auniquely defined value of some type. This does not automatically excludelanguages in which order of execution is important, since we do notrequire the languages to be “pure functional languages”, see for examplein the literature: Sethi, Ravi. Programming Languages, Addison-WesleyPublishing Company, 1990. The term advanced functional language appliesto a functional language which can be used to handle and return morecomplex variables than the basic variable types text and number. Anexample of a very simple source code (module Audio) written according tothe above principle is shown in connection with the description of FIG.8.

In one aspect, the invention relates to a method for visuallyrepresenting in a computer system a program specification, i.e., sourcecode, written in an advanced functional language in a spreadsheet-likecell format and for allowing the execution of the program specificationwithin the cell format. The method comprises:

-   -   communicating with a display device connected to a process        device,    -   accessing a cell frame containing multiple cells displayed on        said display device,    -   displaying text and icons in said cell frame,    -   associating selected variables and corresponding definitions in        said program specification with cells in said cell format,    -   determining values of said selected variables by executing said        program specification, and    -   displaying in cells, associated with said selected variables, an        indication value determined by an indication function        representing values of said selected variables.        The invention also relates to a system which is suitable for        performing the method. The system comprises

(a) Means for communicating with a display device connected to a processdevice. In a normal setting, this may be a program which through theoperating system of the computer displays cell-frames, text and figureson a display device.

(b) Means for accessing a cell frame containing multiple cells displayedon said display device. This may be provided, via a computer program, bynaming the cells and by tracking information about the cells such aslocation and content.

(c) Means for displaying text and icons in said cell frame. This may bea program capable of changing the content of a cell on request.

(d) Means for associating selected variables and their definitions insaid program specification to cells in said cell format. This may be aprogram connecting variable names from the source code to cell names inthe cell frame.

(e) Means for determining values of said selected variables by executingsaid program specification. This may be a compiler and a parser or aninterpreter of the programming language used.

(f) Means for displaying in cells, associated to said selectedvariables, an indication value determined by an indication functionrepresenting values of said selected variables. This may be a programimplementing an indication, function capable of displaying in a cell, anindication value of a variable, defined in the source code by astatement written in an advanced functional language and associated withthe cell, representing objects of a more general nature than formattedtext or numbers. Such objects are, for example, tables from a database,databases, rows from tables, sound and video specifications, geometricalfigures, program parts such as forms, mathematical formulas and manyother objects.

Normal spreadsheet systems do not extend to allow the generalrepresentation of code written/created in an advanced functionallanguage as discussed in the present description.

In important embodiments, the system includes means for displaying thefull value of a variable associated to a cell in the cell format. Thismay be a program communicating to the user additional information aboutthe object referred to by the value associated with the cell andpossibly submitting the value to another system capable of providinginsight into the value when such a system is available. Displaying thefull value thus attempts to display a value in a system native to thevalue. An example of a full value would be to open up a table frame todisplay the content of a table referred to in a cell. This is done,depending on the embodiment, by submitting the table value to a systemcapable of displaying and possibly allowing the editing of the contentof the table in a table frame or including a procedure capable ofdisplaying the content of the table in the embodiment itself. Anotherexample is submitting a sound variable, referred to in a cell, to asound system thus allowing the user to play or edit the sound within thesystem.

In any practical embodiment, the system should include means for editingthe statement defining the variable associated to a cell in the cellformat. These means may, e.g., be provided by a program implementing atext editor displaying the definition of a statement associated to acell, upon request, and allowing the user to edit the statementdefinition similar to the editing of functions and formulas in mostspreadsheet applications. This occurs at a lower level connecting aninput device and a process device in a way which enables the editing.

In some cases it may be convenient for the user to be able to view somepart of the program specifications in a pure text format and theinvention provides means for doing that and for going between the twoformats, i.e., the cell and the standard text format. This feature maybe provided by using the standard text format and by implementing atranslation algorithm, see, e.g., FIG. 10 and FIG. 11, to move back andforth between the display formats.

In an embodiment of the invention, the cell format is used together withadditional means to structure and visualize the writing and editing of aprogram application further. A system suitable for this embodiment wouldfurther include means comprising:

(a) Means for communicating with an input device connected to theprocess device for allowing the editing of text and figures.

(h) Means, provided, e.g., by a program capable of drawing parent-childrelational diagrams, for displaying a modular structure diagram on thedisplay device representing the call declarations part of the programspecification.

(i) Means for organizing the remaining program specification, excludingthe call declarations, of said program specification into predeterminedsmaller parts each containing a selection of variables and theirdefinitions. This may be a program, usually part of the parsingmechanism and possibly accepting user input, to classify the statementsin said program specification.

(j) Means for displaying at least some of said parts and, if desired,each of said parts, on the display device. This feature may be providedby displaying the statements in each part either in text or cell format.

(k) Means for editing or creating the program specification by editingat least some of said parts and/or by editing said modular structurediagram. The editing of the statements in text or cell format may bedone by a text editor as described above. Editing said modular structurediagram is usually done with a graphical editor capable of representingparent-child modular relationships, and the resulting modular structureis translated to conform to the programming language used.

In most programming languages, code can be divided into several partswhich are expressed differently in different languages, but serve thesame purpose. Such a division is obtained by classifying programspecifications into input declarations, output declarations, calldeclarations, call definitions and program statements. For this divisionit is assumed that said input declarations, when assigned values, definevalues of said output declarations using said output declarations, saidcall declarations, said call definitions and said program statements. Itis also assumed that said call definitions define a flow of informationthrough the modular structure existing in the program and that themodular structure is described by said call declarations. An embodimentof the invention uses this classification and represents each of theparts, not necessarily independently, in various formats for viewing,execution, tracing and editing.

Logically this classification is related to the modular structurediagram and, in an embodiment, an association is created between areasof the diagram, for example knots representing modules and linesrepresenting the flow between modules, by assigning at least some of theprogram parts, or if desired each of the program parts, excluding calldeclarations, to specific areas or objects of the diagram. The user canthen access a specific part of the program specifications by using aninput/pointing device to designate an object or area of the modularstructure diagram. These additional means may be implemented usingwell-known program routines.

In another aspect, the invention relates to an application building andsharing environment, comprising:

(a) A collection of, possibly user defined, program modules stored onstorage devices.

(b) Display means capable of defining a work area on a display device.

(c) Module organizing means for organizing a program module from saidcollection into predefined parts including an interface part, calldeclaration part and call definition part. These means may be providedby a program, usually part of the parsing mechanism and possiblyaccepting and storing user input at some point, to classify thestatements in said program module.

(d) Icon representation means capable of assigning icons to at leastsome of the program modules, or if desired each of the program modules,from said collection and capable of displaying said icons on the workarea. This feature, may be provided by associating each module to ageometrical figure or a bitmap and possibly also text and displaying theresulting figure and text on said work area.

(e) Interface representation means capable of displaying, on the workarea, said interface part of a program module from said collection in acell format, using indication values.

(f) Data flow representation means capable of displaying, on said workarea using a cell format, the call definition part of a parent-childmodule relationship within a program module from said collection.Examples are explained in connection with FIG. 7.

(g) Structure means capable of displaying on the work area a modularstructure diagram for a program module from the collection graphically,representing the parent-child module relationships declaration partwithin the program module, see, e.g., FIG. 4.

(h) Sharing means to allow a user to select program modules from saidcollection and represent a selected program module by its icon on saidwork area. This feature may, in one embodiment, be provided by a sharedfolder-like system allowing the user to select the program module andlocate it on the work area using an input/pointing device.

(i) Program module editing means capable of allowing the user to editand add program modules to said collection by editing each of saidpredefined parts of a program module from said collection.

(j) Program module execution means capable of determining anddisplaying, using the interface cell format of a program module fromsaid collection, indication values representing results of executingsaid program module definitions. This feature may be provided by analgorithm implementing an indication function after the execution(implies parsing and compiling or interpreting) of the code has assignedvalues to the relevant variables.

One embodiment of the environment is implemented as follows. The aboveprogram module editing means allow a user of the application environmentto edit graphically said modular structure diagram to create and deleteparent-child relationships within the module. The data flow definitionsare edited within the data flow cell format, explained in connectionwith FIG. 7, and wherein said interface part is edited within theinterface cell format, see FIG. 5 and FIG. 6. The graphical editing ofthe modular structure (call declarations) and the editing of the flowbetween modules using the data flow cell format defines a patchworkmechanism in the environment. Thus, it becomes possible for the user todefine program and flow variables and view their values simultaneouslyusing a patchwork mechanism.

For a user not allowed to change the definition of a particular modulein the collection, this will be sufficient to allow the user to viewresults obtained by executing the module. In order to be able to definethe module, using the cell format, the environment must not exclude theremaining statements (the program part) from being edited in the cellformat.

In an application environment, in which users have access to sharedprogramming modules, there should be some way to control the access ofthe individuals to the modules. In an embodiment, this may be providedby associating with each module, information about the privilegesrequired to use the module and comparing it to privileges of userstrying to access the module.

In a preferred embodiment of the environment it is important to be ableto adjust to at least some other existing programming environments. Thismay be achieved by implementing a compiler, for the programming languageused, returning object code compatible to other systems, also referredto here as exporting a module to another system.

The above application building and sharing environment may furtherinclude means for associating and displaying with the module icon, of aprogram module from above collection, icons representing user selectedvariables within the program module specification. This feature may beprovided by associating a control icon, usually a button, with aspecific variable in the program specification. Then means for allowinga user to access the full value of the variable, associated to thecontrol icon, may be provided by executing, upon request, the programparts needed to define the variable and when the variable value has beendetermined the full value is displayed. Since, for non-constants, thevalue of a variable in a module is only defined when the input variablesare defined, this assumes that the system has available input values forthe module. A suitable way is to store, for each user, the input valuesused in the last execution of the module or a set of default inputvalues. In a spreadsheet system this is always the case, i.e., valuesare not removed from the cells after execution of the program.

In yet another aspect, the invention relates to a method of representingwith an application (e.g. module) icon, at least some of the executableparts from within an application. A system useful for performing thismethod comprises:

(a) A program module, defining an application, specified using anadvanced functional language.

(b) An icon representing said application.

(c) Means for displaying icons on a display device.

(d) Means for allowing a user to select variables from within saidprogram module and represent at least some of the selected variableindependently with a respective icon (such as icon 402 shown on FIG. 4).This feature is provided by enabling the user to choose from the sourcecode which variables should be represented individually.

(e) Means for allowing the user to define the display positions of thevariable icons relative to the application icon. This may be done bystoring and using the relative position, selected by the user, of thevariable icon.

(f) Means for displaying the application icon and the variable icons ona display device in the configuration determined by the user. Thisfeature is usually provided by a figure and bitmap display mechanism andby retrieving the relative position of each of the variable icons fromstorage.

(g) Means for communicating with an input/pointing device and displayingthe full value of at least some of the variables selected when theassociated variable icon is designated by said input device. Thisfeature is provided in a manner similar to the feature discussed aboveand requires the system to have available input values for the module.

This generates a setting in which a user of the application can execute,at run-time, each of the selected variables from within the application.In the case of a value pointing to an external document or object, thisallows the user to access the (selected) external documents used in theprogram module.

Updating child modules in the system generates the well known problem ofcompatibility with existing parent modules. This issue is addressed byproviding the system with ways to graphically represent multipleversions of modules as explained in connection with FIG. 4.

Thus, the system includes means for storing multiple versions of saidprogram module and means for displaying with the application icon a timeaxis and time icons, means for associating to at least some of the timeicons a specific version of said program module and means for displayingthe icon configuration according to the version associated to a timeicon designated by said input device. Using time axes in accordance withthis embodiment can, of course, be generalized, beyond the environmentsotherwise discussed herein, to more generalized settings in graphicalenvironments where multiple versions of programs are used. Thus, thisuse of time axes and icons constitutes a special, independent aspect ofthe present invention.

PRACTICAL APPLICATION OF THE PRESENT INVENTION

The present invention provides an environment (including a system,method, and medium) which enables an end-user, who may have fairlylimited programming language skills, to develop application programs.This is done by providing methods which extend the methodology of aspreadsheet system to a complete application development environment.The spreadsheet methodology is extended to a complete functionallanguage keeping the advantages of spreadsheets for the end-user intact.Thus the invention makes use of the knowledge of a spreadsheet user, tocreate program applications. Further, the invention provides ways toutilize the spreadsheet extension in a patchwork mechanism which allowsthe developer and the end-user to share program components in anend-user friendly way. As a result, the cost of development andmaintenance of new application programs will be significantly reducedbecause the invention utilizes to a greater extent the knowledge of theuser. Moreover the invention provides cost efficiency by allowing reuseand sharing of program modules between end-users and developers withdifferent background by combining the spreadsheet extension with otherend-user friendly paradigms.

BRIEF DESCRIPTION OF THE DRAWINGS

The present invention will become more fully understood from thedetailed description given hereinafter and the accompanying drawingswhich are given by way of illustration only, and thus are not limitativeof the present invention, and wherein:

FIG. 1 is a schematic block diagram of a system arrangement for thepresent invention.

FIG. 2 is a conceptual diagram showing a program module divided intoparts representing program parts defining the module; also shown areexternal applications used in the module definition.

FIG. 3 is a conceptual diagram showing a relationship between a parentmodule and child modules.

FIG. 4 shows modules and external applications represented by icons andrelationships between parent and child modules represented by a modularstructure diagram.

FIG. 5 explains the embedding of a program module into a cell format.

FIG. 6 explains the embedding of a program module into a mixed text andcell format.

FIG. 7 explains the embedding of data flow specifications between parentand child modules into a cell format.

FIG. 8 is an overview diagram showing how the various parts of a programmodule on a text, or other, form are represented visually.

FIG. 9 is a flow chart for displaying a variable value of a statement ina functional language in a cell.,

FIG. 10 is a flow chart for embedding a program source code on text, orequivalent, format into a cell format.

FIG. 11 is a flow chart for translating source code on cell format intotext format.

FIG. 12 is a flow chart for responding to a command to display the fullvalue of a variable.

FIG. 13 is a schematic block diagram explaining multiple displayformats.

FIG. 14 is a block diagram explaining the process of exporting moduledefinitions to other systems and using module definitions with a formdesigner.

FIG. 15 and FIG. 16 are used in connection with an example presented.

Further scope of applicability of the present invention will becomeapparent from the detailed description given hereinafter. However, itshould be understood that the detailed description and specificexamples, while indicating preferred embodiments of the invention, aregiven by way of illustration only, since various changes andmodifications within the spirit and scope of the invention will becomeapparent to those skilled in the art from this detailed description.

DESCRIPTION OF PREFERRED EMBODIMENTS

In the following, examples of embodiments of the present invention aredescribed.

FIG. 1 shows a computer system (100) arrangement for performing thepresent invention. Numeral 101 denotes one or more CPU, 102 denotescomputer memory, 103 denotes data storage such as hard disks or anyother type of data storage, 105 denotes one or more input devices suchas a pointing device and a keyboard, 106 denotes one or more displaydevices capable of displaying graphical and geometrical figures andtext, 107 denotes zero or more output devices such as a printer. Numeral104 designates one or more processors, operating systems and mechanismsconnecting 101, 102, 103, 104, 105, 106 and 107 into a computer system(100). This arrangement includes, but is not limited to, computersconnected together by a network.

FIG. 2 illustrates a generic module. A generic module (202) includes aninterface part (205), connections to other modules (206), data flowspecifications between modules (207) and other program statements (208).Interface part 205 is composed from input (203) and output (204)specifications. Specifications 203, 204, 206, 207 and 208 define output204, sometimes called results, as a function of input 203. Thespecifications (203, 204, 206, 207 and 208) form a program specification(209) defining module 202. Statements in specification 209 can includestatements referring to and using other documents or applications (201).The statements in module (202) can be created using traditional textformat or other alternative formats.

FIG. 3 illustrates relationships (301) between modules. A module (302)of type 202, referred to as parent module, uses results from othermodules, called child modules, by specifying input values or conditionsfor interface part 205 of child modules. Existence of relationships 301is specified in the connections part 206, sometimes called calldeclarations, of module 302 and the flow of data between parent module302 and child modules, sometimes called call definitions, is specifiedin flow part 207 of module 302.

FIG. 4 shows an icon (401) representing module 302. Icon 401 isconnected to other icons related to the module such as an icon (402)representing an external application variable. Each child module isassigned an icon (one of which is numbered 404) and each parent-childrelationship is assigned an icon (one of which is numbered 403, usuallya curve) connecting icon 401 to a child module icon. Each icon isassigned methods capable of responding to input devices 105. Thisdefines a diagram (405) called a modular structure diagram and isdisplayed on a display device. Diagram 405 replaces the need for textspecification for call declarations 206 for module 302, and a user isallowed to create a graphical FIG. 405 instead of writing specifications206. To icon 401 the user has the option of associating another icon(406) referred to here as time axis. On icon 406, time axis, time icons(407) are located representing different versions of modulespecifications 209 for module 302. Which versions are represented byicons (e.g. 407) is determined by the user(s) creating the modulespecifications. Versions of specification 209 for module 302 for which atime icon is placed on time axis 406 are stored along with the currentversion of the specification. Modules having time axis associated withthem are displayed in modular structure diagrams by their icons and withor without the time axis icon depending on whether the current versionof specifications is to be used or an older version is selected. Theversion selected is represented by a time icon (408) having attributesor shapes distinguishing it from other time icons on the time axis.

FIG. 5 shows program module 302 represented in a spreadsheet like format(504), called cell format here, composed of cells displayed on a displaydevice. Cell format 504 contains areas designated as input variables(501) also denoted by i1, i2, . . . , output variables (502) alsodenoted by o1, o2, . . . and manipulation variables (503) definingrespectively input 203, output 204 and program part 208 of module 302.Cell format 504 defines the input output and program part of module 302by a functional language embedded and viewed in the cell format asdescribed by flow chart 901 and explained below. Cell format 504 alsodefines a runtime environment for module 302 by allowing the user tomodify definitions of cells and simultaneously view result of programoperations as is standard within spreadsheet environments.

FIG. 6 shows program module 302 viewed in a mixed cell—and text, orequivalent, format (601) composed of cells 501 and 502 representinginput and output variables and program code 208 represented by a textarea (602) containing a program source code (603). Source code 603together with 501 and 502 define elements number 208, 203 and 204 ofmodule 302 respectively. Flow charts 1001 and 1101 together with flowchart 901 provide methods for translating between text format 602 andcell format 503, if program source code 603 is written in a functionallanguage. Format 601 allows users to view results of program operationsand modify program definitions simultaneously through cells 501 and 502as in format 504. A mixed cell—and text, or equivalent, format enablesthe user to choose a programming environment best suitable and enablesthe usage of more than one programming languages. Users select whichformat to work with, to define and use module 302, by means of inputdevices 105 by choosing from methods attached to icon 401. A full textor equivalent, format is possible and can be translated back and forthto a full cell format or mixed format assuming that the specification isdone using a functional language.

FIG. 7 shows the data flow specifications 301 between parent module 302and a single child module (702). Data flow specifications 301 isrepresented in a spreadsheet like cell format (701) by denoting the rowsin 701 by input variables 203 (denoted by i′1 , i′2 , . . . ) and outputvariables (denoted by o′1 , o′2 , . . . ) 204 from interface part 205 ofmodule 702. Columns are denoted by call variables (denoted by c1, c2, .. . ) in such a way that each column c1, c2, . . . corresponds to a callto child module 702 with input values in rows i′1, i′2, . . . andresults shown in rows o′1, o′2, . . . if the user chooses to viewresults at the same time as specifying data flow 301. Values passed backand forth through relationship 301 are of a general type determined bythe programming language in which program specification 209 of module302 is specified in and the values are embedded into cell format bymethods described by flow chart 901. An alias (denoted by A in 701) isassigned to the relationship between parent module 302 and child module702. Variables (denoted by A:c1:i′1, . . . , A:c2:o′2, . . . ) in cellformat 701 are made available to specification 209 of module 302. Eachparent-child relationship of module 302 is assigned a user editable flowspecification similar to 701 and in this way call definition part 207 ofmodule 302 is replaced by a spreadsheet like environment. Methods foraccessing the data flow specifications between parent modules and childmodules are attached to icons (e.g. 403) between the modules.

FIG. 8 provides an overview over how in the present invention each partof program specification 209 is represented graphically or in cellformat replacing the need for a text specification defining 209. Module302 is represented by icon 401 and time axis 406 to specify version asindicated by line 801 and explained in FIG. 4. Call declarations 206 formodule 302 are represented by modular structure diagram 405 as indicatedby 802 and explained in FIG. 4 also. Interface part 205 of module 302 isrepresented by cell format 501 for input declarations 203 and by cellformat 502 for output declarations 204 as indicated by lines 804 and 805respectively and explained in FIG. 5. Program statements 208 of module302 are represented by, spreadsheet like, cell format 503, as indicatedby line 806, or by text format 602 and explained in FIG. 5 and FIG. 6respectively. Call definitions 207 of module 302 defining the data flowbetween modules are represented by sheets of cell format 701 one sheetfor each relationship in modular structure diagram 405 as is explainedin FIG. 7 and indicated by line 803. Interface part 205 of module 302defines how other modules can access module 302 and in particular can beconsidered a interface into external applications 201 of module 302 ormore generally a interface into a process which combines informationfrom all modules in modular structure diagram 405 and connected externalapplications if present. Type definitions of variables used ininput—203, output—204, call definitions 207 and program statements 208are associated to their corresponding cells in the cell format.

In the preferred embodiment all definitions of modules, representations,users, and icons are stored in a centrally located database (in datastorage 103) accessible to all users. Users share access to modules byplacing icons (e.g. 401) in a folder directory structure, also stored inthe database, defining access rights of other users and associating adescription of the module to the icon for clarity. This enables thesharing of components between users of the system (e.g. network) havingdifferent programming skills, including users with only knowledge ofspreadsheet systems, since data flow between modules can be definedusing cell format (e.g. 701) and a runtime environment is defined by acell format also (e.g. 501 and 502). In order to access a particularmodule, the user, using input devices 105, selects it from its folder,shown on a display device, and places it in a modular structure diagramdescribing a new application or activates it (e.g. runtime environment504). In the preferred embodiment, compiling of modules is done relativeto cells viewed at each moment on the display device used and allchanges in underlying structures are reflected immediately. Users arewarned and informed about how changes in module definitions affect othermodules and have the option of using time axis to leave parent-childrelationships unchanged. The usage of time axis allows existing modulesto function unchanged when modules are upgraded.

Example: This example refers to FIG. 15 and FIG. 16. Here some of thefeatures shown in FIG. 8 are explained. The following is a simple sourcecode written in text format. The language used is classified as an“advanced functional language” by the definition used earlier. Themodule (Audio) searches a table (B2 or “OPERAS.DB”) containing soundfiles and locates the sound according to a keyword (B5) in the defaultkey for the table. The variable B3 represents the row in the tablecontaining the sound specification (B7). The sound specification is in acolumn of the table with the healing “SOUND”.

Module Audio Input(B5 string) Output(B7 sound) Begin B2 :=table(“C:\SOUND”; “OPERAS.DB”). B3 := row(B2; B5). B7 := item(B3;“SOUND”). End.

When viewed in cell format the input 203, output 204 and the programstatements 208 for the above source code are shown using indicationvalues resulting from some choice (made by the user) of input values (B5here, in the below B5 is assigned the keyword “Otello”). Evaluation ofthe module binds the variable B2 to a table object “OPERAS.DB” locatedon a storage device indexed by “C:\SOUND” in this case. The indicationvalue for B2 is “

Operas” which informs the user of the system that variable B2 points toa table named “Operas”. The variable B2 is then referred to in othercells, e.g., the formula row (B2; B5) defines cell/variable B3, in thesame way as in a normal spreadsheet application. When the user isediting a particular cell the original definition of the variable isdisplayed, e.g., when editing cell B2 the text table (“C:\SOUND”;“OPERAS.DB”) is used. Similarly the variable B3 is assigned to a row ofthe table and has indication value “

Otello”

-   -   and the resulting sound object located in the table and assigned        to variable/cell B7 has indication value “        Otello”. An embodiment could thus represent the module using        cell format 501, 502 and 503 as shown in FIG. 15.

When editing the cells B2, B3 and B7 the actual text definitions in theSource code appear as formulas defining the values shown. When editingthe input cell/variable B5 the input value chosen is displayed forediting, here “Otello”.

In some embodiments the, text definitions of all or some of thevariables B2, B3 and B7 will be replaced by other alternative ways todefine and edit the variables.

In order to access the above Audio module from another module (EnhancedAudio below) the user places the audio module as a child module in amodular diagram shown in FIG. 16.

Defining the flow (call definition) between the new module and the Audiomodule is then done by the user using cell format 701 as shown in FIG.16. In the above the input variable of the Audio module (named hereAudio:Selected:B5) is assigned the value “Don Giovanni” and theresulting sound object is assigned to the variable indexed (named) by“Audio:Selected:B7” and shown using indication value “

Don Giovanni”. The variable “Audio:Selected:B7” is recognized in themodule Enhanced Audio in FIG. 16 and is used to refer to the soundobject resulting from the call to the Audio module.

FIG. 9 shows flow chart (901) describing a method for displaying avariable value of a general type in a cell in such a way that extendsthe way mathematical formulas with number values and text is viewed incells. A variable—or a cell value, can be considered an array holdinginformation about the value as determined by the variable type and thevariable definition. The value array is associated to the cell holdingthe variable/cell definition. Information in the variable/cell valuearray is entered into the array by a program execution mechanism whichupdates the value array to reflect changes in other relatedvariables/cells or in the variable/cell definition itself. One type ofthe information in the array is the variable type. The program executionmechanism also triggers the display mechanism to change the displayedvalue of the cell. Values considered are of general types such as anumber, formula, array, geometrical object, form, database, table or arow type as determined by the programming language. A variable of a textor number type is displayed in a cell by its formatted value. The sameapplies to some other types such as date and time. In preferredembodiments, values of more general types are displayed in cells byapplying a function, called indication function here, to the value arraywhich specifies a method, based on the value type, for determining thedisplayed cell value of the variable. The resulting displayed cell valueis a combination of text and icons fitting into a cell. The icons areselected from an icon font and combined with the text to form the celldisplay. Attributes such as color can be applied to the cells in astandard way. An example of such a function is an indication functionwhich assigns to a variable an icon, representing the variable type, andconcatenates to the icon a keyword selected from the information aboutthe variable in the variable array. A value resulting from applying theindication function to a variable is referred to as the indication valueof the variable. The variable array is not displayed but is associatedto the cell. As is standard with spreadsheets, a syntax error in thedefinition of a variable is indicated with an error flag in the cell.Flow chart 1201 describes a method for viewing a variable of a generaltype in another way namely by its full value.

FIG. 10 shows a flow chart (1001) for embedding a program source code ontext, or equivalent, format into a cell format assuming that theprogramming language used is a functional language. Each statement in afunctional language is associated with a variable of some general typeand it is therefore possible to associate each statement and itsvariable to a cell in a cell format as described below. The mechanismdescribed by the flow chart reads the statements in the source code anddetermines (1002 and 1003) into which cell to put each statement. Towhich cell a statement belongs, can be determined by its variable name,information in a cross reference table about a previous embedding from acell format into text format (see flow chart 1101) and adjusted duringmodification of the text to keep track of variables, user input andsequential mapping (that is a mapping of variables into some areacontaining enough cells). The mechanism shown stores separatelyinformation about the text, or other, format, not used in the cellformat, such as the sequential order of the statements in the text(1004). The mechanism shown also reads information about a previous cellformat for the program, if one exists, and formats the cell formataccordingly. Once a location for the statement in a cell and existingattributes have been determined by the above measures, the variable namefor the statement and the cell name are equated and the variable type isregistered in the type array associated to the cell (1005). Conflictswhich arise from naming of statement variables are resolved by alwaysmapping a statement; whose variable name is the name of a cell in thecell format into the corresponding cell. Variable values are thendisplayed in the cell format (1006) as described by flow chart 901 foreach cell after a compiling and parsing mechanism has been activated todetermine the variable/cell value array for each cell used. The programis then edited in the cell format in a similar way as a conventionalspreadsheet. When adding or modifying statements in a cell format thevariable type is determined from the syntax of the statement entered butcan, when more than one types are possible, be adjusted by the user.

FIG. 11 shows a flow chart (1101) for translating source code on cellformat into text or equivalent, format. The mechanism described by theflow chart reads the statement associated to each cell and determineswhich variable name to use in the text format for the statement (1102and 1103). Which variable name to use for a cell can be determined bythe cell name or by a translating table (referred to in flow charts ascell cross reference table). The translating table may containinformation from a previous embedding of the source code into cellformat. Statements in the source code are modified to use the variablename instead of the cell name and attributes and information about thecells are stored separately (1104) to allow for an embedding back intocell format. Information from a previous embedding into cell format canbe used along with other methods such as sequential ordering ofstatements in text and using current attributes of statements in cellsto place and format statements in the text format. Statements arewritten into the text format (1105) and assigned to their correspondingvariables. Information about the type of a variable is contained in thevalue array associated to the variable cell in the cell format andvariables in the text format are declared accordingly using the formatspecified by the (functional) language used.

FIG. 12 shows a flow chart (1201) describing a mechanism for displayingthe full value, by definition here, of a variable/cell value. Thismechanism is triggered for a cell in a cell format by the user using aninput device such as a mouse. The mechanism uses a classification ofvariables by types to determine methods for displaying the full value ofa variable value. Information contained in the variable/cell value arrayassociated to a cell in a cell format points to and is centered aroundexternal documents for many variable types. Example of such types aretable types representing database tables in database systems,graphical—and picture types, sound types representing soundspecifications, types representing word processor documents written indifferent formats and many other variable types. For variable typescentered around external/underlying documents, the full value isdisplayed by activating a process resulting in the document beingviewed/represented and being editable in its native application on aseparated but possibly overlying area, from the cell format, of thedisplay device or on a device determined by its native application.Methods for activating a document in its native application are wellknown in the field and are usually restricted by the operating systemand the native application itself. For other types such as text andnumbers the full value is simply showing available details, determinedusing the value array, in a way which is not restricted, for ex. bysize, by the cell format. Accordingly, since viewing the full value isrestricted by the capabilities of the operating system and otherapplications, not all types are necessarily displayed using full valueas-indicated by (1202) in the flow chart. In the preferred embodiment, alist of methods for displaying the full value is available and searched(1203) and the corresponding method activated (1204) to display the fullvalue of a variable/cell.

FIG. 13 shows a schematic block diagram. FIG. 13 gives an overview ofthe duality between a text and cell format and explains the abovemethods further. Program statements written in text, or equivalent,format are denoted by blocks numbered 1301 and 1303. A statement writtenin a functional language can be considered to be an assignment y=f(x)where y is the resulting variable, x represents the statement inputvariables and f represents the statement as defined by the programminglanguage. Variable y has a variable name and a type definition as shownin box 1301. The statement f(x) is represented in box 1303. Associatedto text, or equivalent, format 1301 is an editing mechanism as shown.Translation mechanism described by flow charts 1001, 1101 translatebetween the two formats. In cell format 1302 the variable y is assigneda cell and the variable—and cell name, also representing the celllocation as is standard for spreadsheet environments, are equated andthus refer to the same variable y. The statement text, or equivalent,f(x) is assigned to the cell and can thus be edited by allowing the userto select the cell for editing its contents as is standard withspreadsheet environments. A change in the cell contents results in achanged definition for the corresponding module. A cell in cell format(1302) is assigned a value array to store information including resultsof program execution as determined by a system (1306) capable of parsingand compiling module definitions (1304), stored in memory 102 and instorage devices 103, into an executable code. Module definitions 1304are stored in multiple formats including graphical specifications (e.g.405) and on cell or text format. A change in a value array triggered bysystem 1306 triggers a change in how the cell is displayed as explainedin flow chart 901 and indicated by line 1307 in the diagram. System 1306is responsible for displaying the full value of a value array asdescribed by flow chart 1201 and explained above. Changes in celldisplay are triggered by changes in module definitions 1304 whichincludes changes in cells being edited as indicated by line 1305.

FIG. 14 shows how, in a preferred embodiment, module definitions areused with traditional form designing environments and other applicationdevelopment systems. Forms provide an alternative format for workingwith modules designed by using the above methods. Module definitions areexported (1404) by an exporting mechanism (1403) into a format definedby an application environment (1405) being exported to allowingenvironment 1405 to access a module as a function with input values 203and return values 204. Exporting mechanisms are well known in the art.In a preferred embodiment, a collection of methods for a predefined setof application environments and operating systems is available definingthe export mechanism 1403. Exporting of modules is controlled by usersof the embodiment. In a preferred embodiment, a form design andimplementation mechanism (1401) is available to users allowing users tocreate alternative display formats in accordance with the designguidelines specified by a predefined list of operating environments.Design mechanism 1401 is capable of accessing and using (1402) moduledefinitions 1304 directly without using an export mechanism byconsidering modules as functions with input—and return values.

The invention being thus described, it will become obvious that the samemay be varied in many ways. Such variations are not to be regarded as adeparture from the spirit and scope of the invention, and all suchmodifications as would be obvious to one skilled in the art are intendedto be included within the scope of the following claims.

1. A method of representing program variables, in a cell frame displayedon a display device, specified by an advanced functional language, theadvanced functional language being defined as a programming languagecapable of handling and returning variables of advanced types inaddition to text and numeric derived variable types and in which each ofthe program variables can be evaluated, based on its dependent inputvariables, to a uniquely defined value, the method comprising: (a)communicating with the display device connected to a process device, (b)accessing the cell frame containing multiple cells displayed on saiddisplay device, (c) displaying text or numbers or icons or other symbolsin said cell frame, (d) locating and accessing at least one externalsoftware component on a network or from one or more central locationsand executing each said software component and representing eachresulting object as one of said program variables of a more advancedtype than the numeric derived or text types, (e) associating saidprogram variables with the multiple cells in said cell frame, (f)accessing said program variables, and (g) displaying in the multiplecells, associated with said program variables, indication values,containing text and/or icons or other symbols as determined by anindication value function applied to each of said program variables,thereby facilitating a platform for testing, using and extending saidexternal software components in a spreadsheet like environment.
 2. Themethod of claim 1, further comprising displaying a full value of atleast some of said program variables.
 3. The method of claim 2, furthercomprising editing values of at least some of said program variables byediting the full value of the variables.
 4. The method of claim 1,further comprising communicating with an input device connected to saidprocess device for editing of said program variables within said cellframe.
 5. A system for representing program variables in a cell framedisplayed on a display device, specified by an advanced functionallanguage, the advanced functional language being defined as aprogramming language capable of handling and returning variables ofadvanced types in addition to text and numeric derived variable typesand in which each of the program variables can be evaluated, based onits dependent input variables, to a uniquely defined value, the systemcomprising: (a) means for communicating with the display deviceconnected to a process device, (b) means for accessing the cell framecontaining multiple cells displayed on said display device, (c) meansfor displaying text or numbers or icons or other symbols in said cellframe, (d) means for locating and accessing at least one externalsoftware component on a network or from one or more central locationsand executing each said software component and representing eachresulting object as one of said program variables of a more advancedtype than the numeric derived or text types, (e) means for associatingsaid program variables with the multiple cells in said cell frame, (f)means for accessing said program variables, and (g) means for displayingin the multiple cells, associated with said program variables,indication values, containing text and/or icons or other symbols asdetermined by an indication value function applied to each of saidprogram variables, thereby facilitating a platform for testing, usingand extending the external components in a spreadsheet like environment.6. The system of claim 5, further including means for displaying a fullvalue of at least some of said program variables.
 7. The system of claim6, further including means for editing values of at least some of saidprogram variables by editing the full value of the variables.
 8. Thesystem of claim 5, further including means for communicating with aninput device connected to said process device for editing of saidprogram variables within said cell frame.